Microsoft Dynamics AX (Archived)

Retail tables

(0) Share

Report

Posted on by Daljit Kaur Rahsi

1,260

Hi,

I have three stores for which the Pay in/out data is not coming up.

I have a store number as 495,714,780.

I can see the Pay in/out data in the RetailTransactionTable, RetailTransactionIncomeExpenseTrans.

When I run a query as - I get 20 rows for both the tables.

-- Returns 20 rows - OK
select *
from retailtransactiontable
where [type] = 18 -- income expense/payout type
and store in (495,714,780)
and transdate >= '20161001'

-- Returns 20 rows - OK
select *
from retailtransactionincomeexpensetrans
where store in (495,714,780)
and transdate >= '20161001'

Whereas RetailTransactionInfoCodeTrans table has no information / rows visible. This is happeneing only in this three stores:

-- Returns 0 results - MISSING
select *
from retailtransactioninfocodetrans
where store in (495,714,780)
and infocodeid = 'Pay In/Out'

No results.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

Which Version of AX are you using?, as per your explanation , it's seems to the data on retail database not pulling in to HQ , is it?.

If you already ran the channel transactions upload job (p-001) & Calculate Statement and still there is no statement generated , you have to check whether Real Time Services running , and check Real time service settings.

hope this will help

Amith Prasanna

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Hi Amith,

I am using AX 2012 R3. I did not try running the channel transactions upload job (p-001) - What does that do?

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,223 on at

Like (1)

Report

First you have to run P-001 upload Jobs to get Data from Store Databases to HQ. then only you have to run calculate statement.other wise it won't replicate data to the HQ by itself, unless you automate P-001 job.

Refer this link also :https://dynamicsaxsharma.blogspot.com/2016/02/retail-pos-sales-and-daily-processing.html

hope this will help.

Amith Prasanna

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Hi,

The P jobs are running with no errors - only these three shops are not receiving the data in the RetailTransactionInfoCodeTrans. Any help / feedback please?

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

I Amith,

I ran the P-jobs, the calculation and posting of the statement was completed successfully - whereas when I go back and check in the RetailTransactionInfoCodeTrans table for this three stores I still don't see the transactions with infocodeid = 'Pay In/Out'

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Check with Scheduler Job (Retail > Setup > Retail scheduler > Scheduler Jobs). Select P-0001 Job and check under subjobs. Whether RetailTransactionInfocodeTrans subjob exist or not.

If not then add it and try to run P Job once again.

Sridharan J

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Hi Sridharan,

It is present.

Was this reply helpful? Yes No