I have a CSV file that I'm trying to load through Data Management onto FCCS. Basically, column 34 is the beginning balance, 35 is the debit amount, 36 is the credit amount, and 37 is the ending balance.
Since on FCCS you either have to load a period change or YTD change and cannot load ending balance unless you're using the ClosingBlanace_Input member as movement, I was wondering if there's a way to do DrCrSplit in the import format for CSV files? The Admin guide and tutorials basically tell you to determine a midpoint between your DR and CR values, but this is for fixed files, not delimited. I don't know how to go about this since my DR and CR values are in the columns next to each other.
If anyone has done this before or has an idea, could you please advise?