1,066
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
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.
[/quote]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 r
left join RETAILTRANSACTIONTABLE t on t.STORE=r.STORE and r.TRANSACTIONID=t.TRANSACTIONID
where 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.
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
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
