Skip to Content
0

UDF for 9999 line restriction per document while posting

Feb 07, 2017 at 01:10 PM

42

avatar image
mockexample.png
Hi Experts,

Looking for a UDF for below logic:

  • File to PROXY, Graphical mapping.
  • In ISL Postings, for each line item, Amount field and Credit/Debit(+/-) Indicator field is taken into consideration for total amount and Debit/Credit indication.
  • If the document is posting to ISL, then the line limit is 9,999 and hence the document should split after the 9,998 line by adding the “Default” account number identified for Balancing Accounts If the sum of 9,998 lines is greater than or less than 0 in order for the overall documents to balance.
  • After the split, it must ensure that all the Debits = Credits and that the sum of Debits and Credits = 0.

Thanks,

Nikhil Aggarwal

mockexample.png (28.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers