424
Hi,
Any body please inform me while posting Transactions, 'items' are getting affected in which all tables?, that is while posting 'open statements'?.
We had an issue of wrong unit cost for 1 item. I want to check where all it is affected while we posted that statement and check it that wron gunit cost still showing there?.
1. Item Ledger Entry.
2. Trans. Sales Entry.
3. Trans. sales entry status.
Any other tables?
Thank you,
Abdul.
*This post is locked for comments
Thank you Alexander and Vishal.
Okay, I am aware that I should not change manually change in tables, this is to keep record of the tables which contains that wrong unit cost entries/records. I am tracking this for any future reference incase any issues happens relating to this.
Thanks again,
Abdul.
While posting the Open Statements, you need to only Cost Value in Value Entry Table and related financials in G/l Entry Table.
Also, you should not change the value from back end in this table at all.
You do not need to do any changes in Trans. Sales Entry or Status table, as these are more of information table and many times you would see the wrong unit cost in these tables, as it would be indicative cost from Item Master Table.
If you speak about the structure of the tables, when you post an item transaction that affects General Ledger, it is posted in the following main tables re cost of goods sold:
- Item Ledger Entry
- Value Entry
- G/L Entry
Other tables, such as Customer/Vendor Ledger entry, Detailed Customer/Vendor Ledger Entry, Sales/Purchase Invoice Header and Lines are filled with purchasing / sales figures.
Learn more about tables:
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
