Description |
* Issue
** Incorrect export file format
* Steps:
** In System Manager > Company Configuration > Card Fueling, Setup Export Transaction To = None/Factor
** Create and Post CF Transactions
** In Posted Transaction tab, Click 'Export to Third Party' grid button
** In Export to Third Party screen, Click 'Tax Group X-Ref'
** Setup a Tax Group X Ref by entering values to the following then Save and Close:
*** State, Customer, Category, Factor Tax Group
** Enter filter in Export to Third Party screen then Click 'Generate':
*** Posted Date From/ To, Include Previously Exported
** Verify exported file
* Requirements
** Factor Tax Group X-Ref
*** Add Column for Category as Optional
*** Update Matching Hierarchy as follows:
**** First:
***** Transaction > Site > State = Factor Tax Group State
***** And Transaction Customer = Factor Tax Group Customer
***** And Transaction > Item > Category = Factor Tax Group Item
**** Second
***** Transaction > Site > State = Factor Tax Group State
***** And Transaction Customer = Factor Tax Group Customer
***** And Transaction > Item > Category <> Factor Tax Group Item
**** Third
***** Transaction > Site > State = Factor Tax Group State
***** AND Transaction Customer <> Factor Tax Group Customer
***** And Transaction > Item > Category <> Factor Tax Group Item
**** No Match
***** Set Export Tax Group as Blank
** Export File Changes
*** Event
**** Sequential Number needs padded to 5 digits
***** Currently 1906131
***** Should be 19061300001
**** Remove Quotes around value
*** Tran Type - Remove Quotes around value
*** Blank Field - Remove Quotes around value
*** Customer # - Pad to 8 digits with leading zeroes
*** Card Number - Remove Quotes around value
*** Vehicle Number
**** Remove Quotes around value
**** Default to 0 when Null
*** Product Number - Pad to 6 digits with leading zeroes
*** Quantity - Remove Quotes around Value
*** Odometer - Remove Quotes around Value
*** Blank Field 1 - Remove Quotes around value
*** Tax 1-7
**** Remove Quotes around value
**** Amounts to 2 decimals only
*** Pump Price
**** Remove Quotes around value
**** Truncate Price to 5 decimals
*** Billing Price
**** Remove Quotes around value
**** Truncate Price to 5 decimals
*** Disc 1,2,3
**** Remove quotes around value
**** Truncate to 2 decimals
*** Unit cost
**** Remove Quotes around value
**** Truncate Price to 5 decimals
*** Total Amount and Total Amount 1
**** Remove quotes around value
**** Truncate to 2 decimals
*** Sell Host
**** Host # from Site
**** Pad to 6 digits with leading zeroes
*** Buy Host
**** When Transaction Type = Local, Remote, Extended Remote
***** Host # from Network Setup > Participant #
****** First Participant #, this field is setup to allow for multiple values
**** When Transaction Type = Foreign Sale
***** We are not capturing this information.
***** Default to 000984
**** Pad to 6 digits with leading zeroes
*** Blank Field 2-7 - Remove Quotes around value
|