10
I am using Jet Reports and can't find the table that gives me the information that is contained in the Screen called "Edit - Average Cost Calc. Overview".
What I'm trying to find is the data that contains the history of dates and unit cost price changes for an item. We use the "Standard Cost" system.
On Friday we updated our standards.
Hi,
Use Value Entry Table for above requirement. It contains all Item entries related cost.
Regards
Amit Sharma
Press Yes if Info is useful
Is your value entry blank? If yes, you have an issue.
If you have inventory in BC, then you have value entries.
The issue here seems to be around how standard cost is used. Let me clarify:
With standard cost method, the inventory cost, therefore, inventory value is not equal to the purchase price.
For example. Item A standard cost £10.00. You receive a purchase invoice at £12.00 each, your inventory cost will still be £10.00 with a £2.00 variance.
The purchase price in the invoice does not change the item standard cost. Nor should users change this value after receiving an invoice.
The standard cost of an item is usually changed after year-end or when you close an inventory period. If you want your inventory cost to be updated depending on the purchase price, you should use FIFO or Average costing method, not Standard.
If you need to see how much your company paid for an item overtime whilst monitoring the difference between the price paid and the standard cost you can run a report on purchase invoice lines (Posted purchase invoice lines).
Alternatively, you can use the value entry table to see all inventory costs allocated to an item like purchase variance and landed costs (Item charges)
I do not need the whole list. I only need to know the effective dates for an Items standard unit cost. Once someone updates the standard unit cost on an item card, you can't use that field for reports run prior to that date for historical use.
I am trying to figure out what an items effective standard cost is during a specific time period. When a vendor's invoice is vouchered, the invoice's price is compared to the standard price in effect at that specific moment. Any difference is recorded as a PPV and posted to the General Ledger's PPV account number. So in order to run a PPV report at any time, for any period of time, I need to pull what the current Standard Unit Cost was that existed at the time of vouchering the invoice. The standard cost field on the Item Card can not be used since it may have been updated after a particular invoice was vouchered.
I don't know what "AL" is? How do I run "AL"?
I am trying to figure out what an items standard cost is during a specific time period. When a vendor's invoice is vouchered, the invoice's price is compared to the standard price in effect at that specific moment. Any difference is recorded as a PPV and posted to the General Ledger's PPV account number. So in order to run a PPV report at any time, for any period of time, I need to pull what the current Standard Unit Cost was that existed at the time of vouchering the invoice. The standard cost field on the Item Card can not be used since it may have been updated after a particular invoice was vouchered.
I am trying to figure out what an items standard cost is during a specific time period. When a vendor's invoice is vouchered, the invoice's price is compared to the standard price in effect at that specific moment. Any difference is recorded as a PPV and posted to the General Ledger's PPV account number. So in order to run a PPV report at any time, for any period of time, I need to pull what the current Standard Unit Cost was that existed at the time of vouchering the invoice. The standard cost field on the Item Card can not be used since it may have been updated after a particular invoice was vouchered.
This table is blank so I assume it is a table that is temporary and used to just generate the information. I am trying to figure out what an items standard cost is during a specific time period. When a vendor's invoice is vouchered, the invoice's price is compared to the standard price in effect at that specific moment. Any difference is recorded as a PPV and posted to the General Ledger's PPV account number. So in order to run a PPV report at any time, for any period of time, I need to pull what the current Standard Unit Cost was that existed at the time of vouchering the invoice. The standard cost field on the Item Card can not be used since it may have been updated after a particular invoice was vouchered.
If you want to get a list of cost entries, I.E. the list of transactions that make the average cost of an item, you need to build your Jet report on the value entry table.
There are additional fields and filters that you need to use to ensure you only get the value entries that make the inventory cost.
One of the fields you need is the source code.
It's not an easy task though. Displaying cost entries is a complicated job and depending on your company's inventory setup, your Jet report might become quite complex.
Is there a reason why you want the whole list?
Keep in mind that the value entry table can became grows quickly as you post in BC. Jet report (Excel) cannot cope with querying large objects line a table with hundred of thousand rows. A Jet report based on value entries can take hours to update.
Hi,
The mentioned table behave like a buffer table, means it generates data on run time, so there is no data to access anywhere, you can use the Value Entry with Item ledger entry or you can drill down the code of Unit cost field in Item card in AL.
Thanks.
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
