Data Import Manager

Is there a template and utility to upload a long JE? I typically have spreadsheets supporting JE's I make - I would like to be able to upload one large JE that I have compiled in Excel at month end / year end than manually typing each of them in Global Shop.

Creditcard.AuthorizationFactor credit card.credit card number Creditcard.ExpirationDate Creditcard.length Credit card.name Credit card.Request Creditcard.ShipAndInvoiceWhen Credit Card Fails Credit card.SurpressInvoiceWhen Prepaid Credit card.Type Credit card.validateBillingAddress

It would be useful to have a Sales/Use Tax Export in accounts payable as the one in accounts receivable. The data for the tax codes gets entered in when putting invoices, however I can't get the data backout without going into the tables.

More detail on the value of fixed assets such as: how many months they should be depreciated, how much they have been depreciated so far, and the date when they will be fully depreciated and should stop further depreciation.

Will there be a ReadMe or Instructions doc to explain what is acceptable and not acceptable for the text file? CSV vs. XLS, max number of columns/rows, what would cause it to not be a valid table, etc?

Be able to set defaults on Boolean and DateTime for all objects. i.e. Billing.Address.IsInternational Data Type: Boolean Mask: True (1, T, t) Set default to be 1 (True) for all objects.

The Comment field is LONGVARCHAR for Pervasive's INV_EXTRA_TEXT: NOTES field; however, the object ExtraText has this Information.Comment as an 8 character string. Is there a DataType for LONGVARCHAR in the objects? I've attached screen shots of the Pervasive table properties as well as the DIM Object Properties for a quick reference.

Can we request that the error log display like it does in other error logs so we are not having to search a temp directory for it?

Could we have the Shipping Phone Number formatted the same as the Billing Fax, Billing Phone and Shipping Fax Number?

Information.Comment Information.Url Information.Sales.Comment