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 originalI 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 originalThank you!!
Here is the GI that I ultimately used.
Can you please share your table joins for INItemstats field for us non-developers. 😁
Thank you in advance.
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.
Here you go. Thank you for the help.
Send the xml you are using i think you may have to join the Cost table cannot remember which one to get it
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.