*NEED SERIOUS HELP* Trying to Export and Import data from sage 300 1

[2ManyHats]

Hey i'm trying to export and import adjustments from sage300. I keep getting this error.

" Description: Can't Append Table. Error: Unspecified error "

It gives me this code. I am trying to make it easier for my office to enter adjustments quicker as well as export them when needed. If anyone can give me some tips or tricks or a step by step run through on how to do this it would be much appreciated. I seriously need all the help I can get on this.

I was told that I might need to create an excel file that contains all of the content needed in order to upload it but i do not know what content I am supposed to put on it. There are tons of categories and i'm not sure which order it would go in either.

Really appreciate it hope to hear back from someone soon.

 

[DjangMan]

Are you applying criteria to your export? Maybe an older transaction is causing an issue. What format are you selecting when you export?

 

[2ManyHats]

Hello,

I finally figured it out and I am able to export the adjustment to excel but now my issues is it is only exporting the headers and not the actual data.

 

[2ManyHats]

Ok so for anyone who was having difficulty like I was, instead of exporting it as an excel document export it asa CSV file instead. I had to get rid of alot of the checkmarks in the header category because it popped up like a blob and it was not fun trying to figure out what everything was.

that is all.