Announcements
No record found.
I keep getting this error when I try to post inventory for my Retail store:
I have checked and the dimension "Color" is already added in all the product dimensions.
*This post is locked for comments
Hi Vickram,
Looks like a data inconsistency issue from HQ to Store
1.Check for the Dimension id details of posted Store trasnactions with HQ
2.Check the values in the Retail trans table,Dimension id has to be matched to allow retail post statement.
3.For posted trasnactions Dimension ID has to be corrected from the backend
4.Run the Products Job to sync data and check the values in store db..
Reagrds,
Girish
HI Girish
I have checked the "RETAILTRANSACTIONTABLE" and there is no column named "Dimension ID".
Please could you help me out with this.
It worked when I added the missing variant ids in RETAILTRANSACTIONSALESTRANS table in database and AOT
You didn't mention the cause and proper solution. Actually, in retailtransactionsalestrans table, variantid field against a specific transaction might have been empty.
Following query will be used to find out that problematic transaction.
select r.TRANSACTIONID,r.ITEMID,r.BARCODE,r.TRANSDATE,r.VARIANTID,r.RECID from RETAILTRANSACTIONSALESTRANS rleft join RETAILTRANSACTIONTABLE t on t.STORE=r.STORE and r.TRANSACTIONID=t.TRANSACTIONIDwhere r.TRANSACTIONSTATUS='0' and t.ENTRYSTATUS <>'1' and r.STORE='12-2020' and r.VARIANTID=''
Once identified, you can simply go to relevant item, find the missing variant on the basis of barcode and simply update retailtransactionsalestrans table.
Pls. mark the question as answered after verifying at your end.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
