restriction grouping issue (bug?)
sid jayawardena asked 7 years ago
i have the following data in CSV
date,debit,credit
8/1/2015,10,0
8/1/2015,0,10
9/1/2015,0,10
9/1/2015.10.0
9/1/2015,0,0
I created a restriction to ignore lines where debit is zero and credit is 0 in *both* the add distribution and create journal nodes of the general ledger transaction
I grouped the create journal based on date
When I run the map, it generates 2 line and 1 header inserts for the 8/1/2015 journal entry
For the 9/1/2015 journal entry, it only generates two lines but no header
I believe that is because the grouping logic is ignoring the restriction and never firing at the end of the 9/1/2015 group
http://www.eonesolutions.com/discussion/node-tapmtransactioninsert-not-found-in-pmtransactiontype/
the report above comes from someone trying the same thing in payables and having the same issue – the response to that was to filter at source rather than using restrictions
Is there a proper workaround that doesn’t involve filtering at source? (in that case, what is the point of a restriction?)
Will this be fixed in an upcoming release?
date,debit,credit
8/1/2015,10,0
8/1/2015,0,10
9/1/2015,0,10
9/1/2015.10.0
9/1/2015,0,0
I created a restriction to ignore lines where debit is zero and credit is 0 in *both* the add distribution and create journal nodes of the general ledger transaction
I grouped the create journal based on date
When I run the map, it generates 2 line and 1 header inserts for the 8/1/2015 journal entry
For the 9/1/2015 journal entry, it only generates two lines but no header
I believe that is because the grouping logic is ignoring the restriction and never firing at the end of the 9/1/2015 group
http://www.eonesolutions.com/discussion/node-tapmtransactioninsert-not-found-in-pmtransactiontype/
the report above comes from someone trying the same thing in payables and having the same issue – the response to that was to filter at source rather than using restrictions
Is there a proper workaround that doesn’t involve filtering at source? (in that case, what is the point of a restriction?)
Will this be fixed in an upcoming release?
Answers
Patrick Roth Staff answered 7 years ago
sid,
This works fine. I would suspect that you are doing what I accidently did.
In my haste, I forgot to mark the grouping on the header on the Key field – which _should_ be Date based on your sample data.
Once I marked the Group checkbox and selected the Date field to group on, SC generated the proper XML for the gl trx entry and also filtered out my zero debit/credit line as expected.
Patrick
eOne
This works fine. I would suspect that you are doing what I accidently did.
In my haste, I forgot to mark the grouping on the header on the Key field – which _should_ be Date based on your sample data.
Once I marked the Group checkbox and selected the Date field to group on, SC generated the proper XML for the gl trx entry and also filtered out my zero debit/credit line as expected.
Patrick
eOne
sid jayawardena answered 7 years ago
thanks for the quick response patrick but the grouping box is checked for date and currency
when I dug deeper I found that the order of the data seems to matter
if i run the file below against my map, the journal entry for 9/1 is missing the header
date,debit,credit,account,currency,import
7/17/2015,0,0,10-0-0,CAD,no
7/17/2015,0,0,10-0-0,CAD,no
8/14/2015,0,0,10-0-0,CAD,no
8/14/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
7/31/2015,0,731.12,10-0-0,CAD,
7/31/2015,731.12,0,10-0-0,CAD,
8/1/2015,8.12,0,10-0-0,CAD,
8/1/2015,0,8.12,10-0-0,CAD,
9/1/2015,9.12,0,10-0-0,CAD,
9/1/2015,0,9.12,10-0-0,CAD,
8/31/2015,831.12,0,10-0-0,CAD,
8/31/2015,0,831.12,10-0-0,CAD,
however if i run the file below using the same map, the header for all transactions are present
date,debit,credit,account,currency,import
5/1/2015,0,0,10-0-0,CAD,no
5/1/2015,0,0,10-0-0,CAD,no
6/1/2015,6.12,0,10-0-0,CAD,
6/1/2015,0,6.12,10-0-0,CAD,
7/1/2015,7.12,0,10-0-0,CAD,
7/1/2015,0,7.12,10-0-0,CAD,
9/1/2015,9.12,0,10-0-0,CAD,
9/1/2015,0,9.12,10-0-0,CAD,
8/1/2015,8.12,0,10-0-0,CAD,
8/1/2015,0,8.12,10-0-0,CAD,
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
10/1/2015,0,0,10-0-0,CAD,no
10/1/2015,0,0,10-0-0,CAD,no
have you any idea of why this would be?
when I dug deeper I found that the order of the data seems to matter
if i run the file below against my map, the journal entry for 9/1 is missing the header
date,debit,credit,account,currency,import
7/17/2015,0,0,10-0-0,CAD,no
7/17/2015,0,0,10-0-0,CAD,no
8/14/2015,0,0,10-0-0,CAD,no
8/14/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
7/31/2015,0,731.12,10-0-0,CAD,
7/31/2015,731.12,0,10-0-0,CAD,
8/1/2015,8.12,0,10-0-0,CAD,
8/1/2015,0,8.12,10-0-0,CAD,
9/1/2015,9.12,0,10-0-0,CAD,
9/1/2015,0,9.12,10-0-0,CAD,
8/31/2015,831.12,0,10-0-0,CAD,
8/31/2015,0,831.12,10-0-0,CAD,
however if i run the file below using the same map, the header for all transactions are present
date,debit,credit,account,currency,import
5/1/2015,0,0,10-0-0,CAD,no
5/1/2015,0,0,10-0-0,CAD,no
6/1/2015,6.12,0,10-0-0,CAD,
6/1/2015,0,6.12,10-0-0,CAD,
7/1/2015,7.12,0,10-0-0,CAD,
7/1/2015,0,7.12,10-0-0,CAD,
9/1/2015,9.12,0,10-0-0,CAD,
9/1/2015,0,9.12,10-0-0,CAD,
8/1/2015,8.12,0,10-0-0,CAD,
8/1/2015,0,8.12,10-0-0,CAD,
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
9/1/2015,0,0,10-0-0,CAD,no
10/1/2015,0,0,10-0-0,CAD,no
10/1/2015,0,0,10-0-0,CAD,no
have you any idea of why this would be?