I can not get my Item costs(Avg cost) to report on the stock items GI table. They all report as zero.
Solved
Avg cost not reporting on stock Items GI table
Best answer by srommel
Good Day,
I was able to solve the problem. It required me to use the INItemstats field. It is odd that the there are multiple ways to get the same information, but not all field functions work the same. I still need to learn more about all the relations between the field functions.
Thank you for your assistance.
+15Can you share the GI from memory average cost is not stored but caculated from Total Cost divided by Qty.
Are you looking for a screen shot or a XML list? Our Item costs are setup to be avg cost. On the GI stock item table I can see a standard cost column option but nothing is reported on the table except zeros.
+15Send the xml you are using i think you may have to join the Cost table cannot remember which one to get it
Dermot Comerford
1 person likes this
Good Day,
I was able to solve the problem. It required me to use the INItemstats field. It is odd that the there are multiple ways to get the same information, but not all field functions work the same. I still need to learn more about all the relations between the field functions.
Thank you for your assistance.
Can you please share your table joins for INItemstats field for us non-developers. 😁
Thank you in advance.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.