SAP B1 A/R Invoice row Linetotal - UDF

[mants3]

Dear Experts,

I have an urgent request and I need your help. A customer's request. On the A/R Invoice row, we have the Tax column.

Scenario:

I have four lines on the A/R invoice row level. Out of the four lines, two have tax applied and the other two do not have tax applied. I want to sum the total of Linetotal without tax and also separately add the other two with tax applied Linetotal. I want these added on UDF on A/R invoice header so I can apply them on SAP B1 Crystal report showing those without tax applied LineTotal and Tax applied LineTotal .

Sum of LineTotal without applied tax = Non-Taxable

Sum of LineTotal with Applied Tax = Taxable Value

Regards,

Justice

[LoHa]

Hi Justice,

and other idea could be a post trasnaction notification with the sum and you fill the UDF manually

regards

Lothar

[narayanis]

HI,

Seems very difficult and tricky because you want to capture the line level cumulative data at header level. In first place, FMS will not auto execute because, for auto executing a FMS, you will require line level field which will be not available because FMS is getting applied at title level. So, FMS execution will be manual.

Second, there are two different data sets basis tax application criteria. So to get the data, first you will have to manually set the criteria to get the cumulative total and then click on the individual row satisfying the condition.

I will suggest you to get line level total for data with tax and data without tax in two separate line level udfs which can be done easily through FMS and then play in crystal by sub - report.

Still, I tried a small workaround and tested.

Created a udf of type at header level of sales order as units and total and structure quantity

Created FMS query - SELECT $[ORDR.U_TotlQty.Number] + $[RDR1.Quantity.Number]

applied this on above created udf

Then as i record the line level details of the sales order, before going to the next row, you will have to click on the udf to get the cumulative total.

This is very tedious. User can forget or make mistakes here. This is not feasible