The cost tier is an important costing feature provided by IM which allows the system to track the actual cost at which an item was purchased every time.
Sage 500 stores the cost in table timCostTier . Here is the schema for that table:
A cost…
We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…
Hi Guys,
I am having an issue while updating Inventory Counts in SAGE300.
I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities.
Has someone successfully updated /C Physical Inventory…
