[GNC] Importing Vendor Bills: Field Definitions Questions
Fran_3
mailbox0600 at yahoo.com
Sat Feb 15 13:53:41 EST 2020
Referring to the field definitions in
18.1. Importing Bills and Invoices
I tried to line those up with the three dialog boxes that come up as you create and post a new bill.
New Bill DialogEdit Bill DialogPost Bill Dialog (aka Question)
I think I have most of them properly associated but need help on a few...
-
owner_id - Customer or vendor number. Mandatory in the first data row of an invoice. If not provided, all rows of the same invoice will be ignored.
I don't see "Owner ID" in any of those three screens... but I do see a field for the Vendors name in the "New Bill" Dialog.
However I do see it in the "Vendor Overview" list of vendorsI guess that means one would have to lookup the Vendor Number for each vendor's bill they are about to import.
(This is the case of having a clerk enter the bills into a spreadsheet so that a the GC admin could import them later... as when you don't want the data entry clerk to see all your financial data :-)
Now that I think about it that makes sense as the data entry clerk could misspell the vendors name or enter it differently than it is in the system... so maybe I just answered that one for myself.
Next I see these fields... again I couldn't find them in any of the three dialog boxes that appear when you are creating/entering a new bill... or did I miss them somewhere. Maybe somebody can point the discount fields out to me wherever they are.
-
disc_type - Type of discount. Optional. Only relevant for invoices, not for bills. Use “%” or blank for percentage value, anything else for monetary value.
-
disc_how - Discount how. Optional. Only relevant for invoices, not for bills. Use “>” for discount applied after tax, “=” for discount and tax applied before tax, and “<”, blank or anything else for discount applied before tax.
-
discount - Amount or percentage of discount. Optional. Only relevant for invoices, not for bills
Another question... and maybe I missed it... but is there anyway to import bills from a CSV file but not have it automatically Posted?
Finally, for anyone interested...
These import fields match the "New Bill" Dialog fields...(except Billingid... which on the dialog is the Vendor Name field)
Id
Date_opened
owner_id
Billingid
Notes
These import fields match the Edit Bill Dialog fields(except I can find the 3 Discount Type fields.)
Date
Desc
Action
Account
Quantity
Price
Disc_type
Disc_how
Discount
Taxable
Taxincluded
Tax_table
And finally these import fields match the Post Bill Dialog fields
Date_posted
Due_date
account_posted
Memo_posted
Accu_splits
More information about the gnucash-user
mailing list