I can not get my Item costs(Avg cost) to report on the stock items GI table. They all report as zero.
Best answer by srommel
View original
Userlevel 7
+12
Can 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.
Userlevel 7
+12
Send the xml you are using i think you may have to join the Cost table cannot remember which one to get it
Here you go. Thank you for the help.
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.
Userlevel 7
Thank you for sharing your solution with the community
Can you please share your table joins for INItemstats field for us non-developers. 😁
Thank you in advance.
Here is the GI that I ultimately used.
Thank you!!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.