R42800 does not summarize taxable and non-taxable in one line in F03B11

[dschlieder]

All,

We are in the midsts of upgrading to ERP8 and an issue arised.

R42800 is set to summarize AR entries - and it does if all of the lines of an invoice are taxable or if they are all non-taxable.

But if an invoice has both taxable and non-taxable lines, it summarizes taxable and non-taxable as separate lines in the F03B11 instead of 1 line.

Now I believe it is supposed to work that way, I think. But it isn't working that way in 7332 and the users are upset and want the IT department to fix it.

But I can not find any processing option or set up or UDC and I'm not too thrilled about trying to change the c code (I can't see where it is making two lines anyway).

This has been an issue in the past and our poweruser supposidly fixed it. But he is gone and there is no documnetation nor any code change I can see made by that user.

Anyone have any ideas?

Thanks!

 

[TRathjen]

See SAR 6847296. Anyone else who would like this fixed please add yourself to the SAR, it is currently awaiting staff.

 

[dschlieder]

Tim,

Thanks for that info! I never came across that one in all my searches in the KG and I have spent days trying to figure this one out - I can no move on to something else!

Dave

 

[dschlieder]

Tim,

In case you don't want to wait for JDE to release the SAR, here is the change we put in and are currently testing. We disabled a number of lines that deal with the tax area and explanation.

=======================================================================
SECTION: Sales Update And Report [GROUP SECTION] (S6)
=======================================================================
OBJECT: SECTION
EVENT: Do Section
-----------------------------------------------------------------------
...
...
1232 If VA evt_FreightAllocationFlag_TV05 is not equal to "2"
1233 //
1234 RV EV06-F0311LineErrors(wf) = " "
1235 // Begin SAR 6321382
1236 //
1237 // If the line is non-taxable blank out the tax fields, this will prevent A/R
1238 // from writting tax amounts (SAR 6317261)
1239 //
1240 ! If BC Sales Taxable (Y/N) (F4211) is equal to "N"
1241 ! VA evt_F03B11TaxExplanatnCd_EXR1 = " "
1242 ! VA evt_F03B11TaxArea_TXA1 = " "
1243 ! Else
1244 VA evt_F03B11TaxExplanatnCd_EXR1 = BC Tax Expl Code 1 (F4211)
1245 VA evt_F03B11TaxArea_TXA1 = BC Tax Rate/Area (F4211)
1246 ! End If
1247 // SAR 6317261 End
1248 F03B11 Edit Line
...
...

The changes made by SAR 6317261 set up this issue. I guess the programmer didn't realize that a sales order can have both taxable and non-taxable lines.... Or there may be more to this than meets the eye. But with the above change, we only get one F03B11 and it posts to the F0018 correctly now.

Dave