I don’t want to distinguish the elements of the goods. I want to distinguish the income from the sale of the goods based on the country where I sell the goods
You might consider a custom field named something like Sales Location. Then create Sales Invoice Totals by Custom Field reports.
Yes, I think so. Purchase invoice item quantity to one inventory location, e.g. Domestic. Then you can change from one inventory location (Domestic) to the other (e.g. Export) by means of a journal entry (enabling the Quantity column allows you to enter a quantity). Inventory transfer doesn’t work in this case. And you use separate item codes and income accounts as @VACUUMDOG has indicated to distinguish between domestic and export sales.
I am not sure I understand this statement, @Mark. Why would it not work? Both inventory locations would be virtual. But you could sell from either one. (Although, I think that is more work than the custom field approach, since the only thing @eperion wants is a sales report by sales location.
Because you cannot transfer 2 items with a different item code.
OK, @Mark. I see your point, if you are combining different inventory locations with different inventory items. But that entire approach seems like a nearly endless rabbit hole: 2 defined inventory items, 2 inventory locations, 2 custom income accounts, and a journal entry, all for the sale of one item that in reality is purchased and stored at a single place.
I guess the best solution comes down to what @eperion’s real goal is. If the goal is to see segregated income reported on the profit and loss statement, there is no way around a complex solution. But if the goal is only to know how much was sold to foreign customers versus domestic, the custom field and corresponding report is far easier.
1 Like
hallo @eperion
maybe here is an answer for one of your problems
look at tut s post 12:
As I said before, consider obtaining this information from the tax reports. You would normally be assigning different tax codes to transactions for EU and non-EU customers and suppliers. Did you try that?
it kind of works with tax codes
1 Like
I know it’s a bit of extra work to set it up as I did, but I just like to try things out and it works well.
Corrected the error because those sales belong to Inventory - sales and not to the non-inventory sales category.
I think the best way will be to creat two sales account. One for local sales and the other for foreign sales.
That’s what both @AJD and @VACUUMDOG already suggested so in which way is your suggestion different from theirs?
I have been facing this problem even with other accounting programs.
Some programs connect the sales account (Domestic or Export) to the type of the customer.
Which means adding new differentiation to the customers’ panel.
Like what we do with inventory items upon choosing the specific income account.
Other programs cannot solve this issue, and they depend on the moving of items like what @Mark has just explained.