Hi John,
The sales taxes are uniform in application here but there are US jurisidictions with special tax districts (usually to subsidize stadiums) where the special tax applies only to certain goods.
So there would have to be some sort of identifier to mark certain taxes as uniformly applied and others as variable (and therefore stored with particular transactions in my app).
I was thinking of setting _4_ taxes are worst case scenario in the table structure... with some being left NULL; controlled by values in configuration file.While I am subject to a maximum of three different sales tax rates, I must itemize total sales and tax collected by county and special tax district.
So each tax would have a different account number, even for the same taxs but different county or taxation district... correct? ( Making for an interesting COA ).
I'm interested in generating the journal transactions in my app (Open Admin) and then exporting them to ledger-smb. For this to be useful in your area, I would have to know all of your account numbers for these Tax Payable accounts (stored in OA) and then tag the transactions with the appropriate account numbers.... these tax things make everything so... ugly! (grin)
Do you see any holes in my reasoning above? Thanks, Les Richardson Open Admin for Schools