I want to tag the Account Receivables Account to a Customer (Cash Sales) to GL Account "Cash Account".

But when I drop-down to select account, it doesn't show the Cash Accounts. I want the Account Receivables Account to be tagged to Cash Account, but FA doesnt let me do that.

Select Customer
Click Add Edit Branches

GL Accounts
Sales Account:   
Sales Discount Account:   
Accounts Receivable Account:   
Prompt Payment Discount Account:

Right. Something like the foreign currency change. I think we can handle the inventory price increases by having an extra tab in the Items & Inventory--r> Maintenance-->Items screen.

One should select the Item, which should list the current price and the create date. Then the exact routine for foreign currency change should be run below. The pricing in Sales/Purchasing Tab in Items should list the relevant prices mentioned in the Extra Tab.

Hope I am making some sense! lol

Hi

How do I handle price increases by a supplier for his products? I want to retain the previous price history as well.

Scenario:

1. I am selling Item-A from Vendor-A at a Sales price of $10 (purchase price is $6)

2. From 01-Jan-2017 the Supplier will increase his price from $6 to $8.

3. I will also increase my price from $10 to $12.

Requirement:

1. I want the system to keep on invoicing my customers @ $10 till 31-Dec-2016.
2. With effect from 01-Jan-2017 I want the system to automatically start using the new prices
3. I want the system to maintain a history of both, sales/purchase price change and effective dates.

Please help!
Cheers!

Hi  Anoop

It is great to see your interest in FA. Is it possible to send me the link to the demo?
Regds

Tariq

Thank you for a prompt reply Joe. Will wait for the extension :)

In the meanwhile, I will talk to my IT team to tweak the code handling Salesmen provisions etc.

Cheers!

I have my salesmen listed as follows:

Salesman-A - Provision-1=5%           Breakpoint=200,000              Provision-2=10

This is because, I want salesmen to get 5% provision (commission) on all sales, until the 200,000 marker is reached. Any sale over 200,000 will attract a commission of 10%.

But FA calculates all sales @5% irrespective of whether it is less or more than 200,000, which is wrong.

Why is it not calculating the commission on invoices that should attract 10% commission?


And, secondly, on a related note:

How can I make FA to debit the Commission Expense Account and credit the Sales Commission Payable A/c? Because I can't see the commissions calculated by FA being shown in the Trial Balance at this time.

I think, a facility should be provided when setting up Sales Persons, where it should ask:

Specify Commission Expense Account: 61013009 (which will be common for all salesmen.

Specify Salesperson Commission Payable A/c: 21020001 (Specific to Salesman-A)
                                                                         21020002 (Specific to Salesman-B)

I have not see any module as such. Maybe you will need to play around with the Sales module to get what you want. But then this seems to be specific sales segment that you want FA to help you with. Don't think that will be possible without some modifications to Sales module.

This looks to me, to be for a real estate company. You could have GL accounts set up like, Sales Price, Booking Charges, Delivery Charges etc.

But Admin can probably answer this better!

33

(7 replies, posted in Accounts Payable)

Joe, Any plans to build this into FA some time soon?

What guidance would you give if we want to execute it on our own. This would be a very useful function from the managements perspective.

Hmm.. Can't we use it for a sub-account or something Joe?

And if it is used for summarizing info, how is it used? Do we filter account code 2 in the reports?

What is the Account Code 2 field for when we are creating a GL Account?

36

(2 replies, posted in Installation)

majonil033 wrote:

I would like to consider FA for hospital or medical ERP will it be possible or any guidance?

Did you manage to complete the FA for medical ERP? If, yes, would like to discuss a few things with you on this.

Can we not do it through Dimensions? And if yes, HOW?

hmmm... Thanks apmuthu. Let me think this over.

But then, FA asks me to have a sales person associated with each customer (aka student). Actually there won't be any sales person involved.

And secondly, a Tax ID has to be associated with each customer too, which in this case won't be required.

I have gone through the forums but have not been able to see any solution on my problem statement so far.

1. We have 10 schools in different locations (we call each location a Branch), each covering Grade-1 to Grade-10. I want FA to keep a complete track of students location-wise and also inform the management about Fee Receivable for each location separately.

2. I want the have a separate Income Statement and Balance Sheet for location and then a consolidated Income Statement and Balance Sheet for the whole Company.

3. Whenever a user logs in from a location, he/she should ONLY be able to see transactions related to Students, Fees, Receivables, Vendors/Payables, Trial Balance for that particular location only.

4. Sometimes, a student gets transferred from one location to another location. How do we handle this issue in FA? Should we give him a new Registration number at the Recipient location.

This is it so far!

40

(8 replies, posted in Accounts Receivable)

I will tend to agree with dvarsani to some extent. Tax rules vary from country to country and where taxation depends on company registered address (as compared to place of activity) the branch concept becomes superfluous.

I would suggest that FA should give an option whether to select BRANCH or not.

Hi,

We are a service company and trying to move from Peachtree 2010. I have set up my customers. And I don't think there is any linkage between customers and inventory that I have selected in FA system. Yet, when I try to invoice a customer, I get the message "There are no inventory items defined in the system."

Where am I going wrong?

Cheers!
TOR

The forms set up only gives facility to set up Bank Payments. And even there, there is no field for cheque numbers.

My question is: If I am paying by cash, and want to have the form reference as CPV (Cash payment Voucher), how do I do that?

Cheers!
TOR