You need to read and understand the various Guides concerning base currency, foreign currencies, exchange rates, sales invoices, customers, and tax codes. Create a test business (you can have as many businesses as you want in Manager) and experiment.
In the future, please do not divert topics with unrelated questions. See FAQ - Manager Forum. Your question has nothing to do with custom fields. And you do not need to modify invoices to accommodate your needs.
After you have read the Guides and experimented with a test business, if you still have specific questions, start a new topic with an appropriate subject.
noted yours below.
However, please not the item amnt as shown in my query is variable and changes from invoice to invoice.
besides, the exchange rate (ROE) also varies from invoices as they change on hourly basis. Hence a ROE has to be inserted for every exchange rate.
I am unable to factor all these.
@RAM93, I guess you ignored my comments about diverting topics. Your post and the responses to it were moved to a new topic. Please do not do that again.
You also apparently ignored my advice about reading the Guides and starting a new topic. When you have done all that, you will be able to get help on the forum by illustrating your exact situation with screen shots from the test business.
item = USD 100$ (trying to insert this in unit price . However, unit price has to be in dollars . tried to use inventory/non inventory feature. However, this value is variable and changes for every invoice. therefore creating inventory field seemed to be unhelpful.).
Exchange rate=70$ (system provides only one place to insert the ROE at the settings. This is not suitable as the exchange rate applicable changes for every invoice. Hence require a cell here to insert the rate. custom field was not able to used in calculation).
Total= displayed correctly in the total column in INR.
brokerage (my income)= Wasn’t able to get this inserted. Looked into other threads on this where i saw the suggestion that commission should not be inserted using tax codes feature.
GST on brokerage(18%)= yes, was able to create a tax code for this.
TOTAL AMNT PAYABLE= is displayed properly.
I would like to seek my assistance for below points.
Supplier A who sells a service (USD price fluctuate as per market)
Buyer B who requires a service.
I as an intermediatry connect the two parties for which i receive commission.
The sale and puchase occurs in USD.
For the service i provided , i receive a commission in INR. The exchange rate applied basis the time/ date when the service was delivered by the buyer to seller.