Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Sukrut Parab 2 Moderator
