Skip to Content
0
Former Member
Jun 05, 2009 at 09:05 PM

Reversal Entry into DSO - Issue

107 Views

Hello Guys,

I am loading the data from table(name - ZSAFCST into DSO (ZSD_O44).

Table is having following fields.--. Sales Doc, Item no, invoice Date, SD Record Type, Indicatory (Reverse Marking), sales total and sales qty.

2 fields --> SD record type and Indicatory (reverse marking) are FLAG fields in the table, based on which they change and delete the data in the table.

every day the data is loaded into the table with SD Record Type = 'D', with no value under Indicatory field.

At the month end they will do a reverse by sending the completed records for that whole month with SD record type = '' and Indicatory = 'M'.

this entry will delete all the records in the tables.

then again they will load the actual data info the table with SD record = 'D' and Indicatory = 'M', which will not be changed or deleted.

again for the next month they will start loading the records into the table with SD record type = 'D' and the same process continues.

we need to load the daily recrods into BI since its required for our forecast calculations.

So please let me know, if DSO can handle this scenerio...if not what are the avialable options for me.

thanks,

Pra