OverviewThis section of the knowledge base provides information for developers of Salesforce and Accounting Seed. Accounting Seed uses the Salesforce API which is fully documented at https://developer.salesforce.com/. Accounting Seed extends the Salesforce API with Global Classes for our posting process of Billings, Accounts Payable, and Journal Entries.
Common Integration Points
- Journal Entry
- Cash Receipt & Cash Application
- Account Payable
- Cash Disbursement
Source Objects for the General Ledger
|Source Object Name||Global Posting/Unposting Class Accessible Via Apex||Rest API for Posting/Unposting|
|AP Disbursement||No, But posts automatically||No|
|Billing Cash Receipt||No, But posts automatically||No|
|Time Card Day||No||No|
|Purchase Order Inventory Movement (ERP Package)||No, But posts automatically||No|
|Inbound Inventory Movement (ERP Package)||No, But posts automatically||No|
|Manufacturing Inventory Movement (ERP Package)||No, But posts automatically||No|
|Outbound Inventory Movement (ERP Package)||No, But posts automatically||No|
|Sales Order Inventory (ERP Package)||No, But posts automatically||No|
Accounting Seed made a deliberate decision to maintain the flexibility of the Salesforce platform and build Accounting Seed as natively as possible. This means you can customize and configure our objects and page layouts just like you can with any custom object in Salesforce.
Ultimately, any object in Accounting Seed can be integrated to from outside of the General Ledger tables described above. However, the three most common integration points are the Billing, Payable and Journal Entry.
Customizable Objects and Page Layouts
Custom Fields, Workflow Rules, Process Flows, Approval Rules, Validation Rules, and more are all available tools that Salesforce supplies and can be leveraged in the same way with Accounting Seed.
Accounting Seed is often used with other AppExchange apps that are developed in the same open architecture, native way.
Document generation products can also be used to generate customer/vendor facing documents such as Invoices, Statements, Purchase Orders, and Packing Slips.
There are, however, three Accounting Seed objects that drive the integrity of the General Ledger data that we prevent anyone from editing either manually, via the API, or through declarative Salesforce tools. They are:
Financial Cube Object
Financial Cube Transaction Object
Commonly Customized Functions
There are a few areas of customization we see customers request that Accounting Seed will not be building into the application. These areas tend to be something that each customer does differently so they make ideal customization candidates. Here are five of the most common:
Expense Allocations: For example spreading expenses of a shared resource across multiple business units.
Sales Commissions: This is unique to each customer’s sales compensation plan, the Opportunity, Billing, and Cash Receipt data is all available to be used for this calculation.
Revenue Recognition: This is unique to each customer’s business model. Percent complete of the sale or job, as well as amount invoiced to date are both components of this solution.
Inter-company Transactions: When a company has subsidiaries or multiple related entities, it is almost always necessary to make adjusting entries to avoid counting transactions in both sets of books. These are generically known as inter-company transactions and are unique to the companies operating practices.
We are using Scheduled Revenue Expense to capture securities trades, manually creating one SRE for each trade. Trades are captured in a trade ticketing system which is built on MS Access. For this use case, SRE's are much better than Journal Entries. We would like to automate the creation of the SREs. It's not clear to me from this article whether that is possible or not.
You can absolutely insert scheduled revenue and expense records from the API. This is a simple insert statement with the required fields for the record: Name, Amount, Debit GL Account, Credit GL Account.
We have our own invoicing and accounts payable modules but we would like to use the API to post the entries AS. We also need to handle taxes across two countries, Singapore and Indonesia, this means the way we handle the taxes has big variation. How flexible can we work with AS to make financial reporting seamless? How can this be done?
Yes absolutely. Accounting Seed serves great a s general ledger that you can integrate to and use for financial reporting. The Journal entry object would most likely be you integration point. Please email me directly at firstname.lastname@example.org if you would like to setup a call to discuss.
Hi Tony, Thanks for your reply
Are we able to develop our own order receiving functions and then insert the quantity into the inventory module using the API? Can we do the same for drawing out inventory for use?
yes, You would use our standard inbound and outbound inventory movements to do this.
Hi Tony, are you suggesting that our order receiving object will use the inbound object to stock in and then our Inventory request module will use the outbound object to update the movement?
yes, this would be one way to integrate.
Thanks Tony, What another way?
For your information, our procurement Management System is developed using Force.com and we need to send information to the Accounting Seed system? How do we make this integration work?
There are several ways that this could work. We would need to have a call to discuss.
How can we create Sale Orders in Accounting Seed via the API? Is that supported?
Yes, just insert these data records just link any other records you would insert via the API.
Is it possible to programmatically check to see the status of all the processes that are run when a period is open or closed? I'd like to automatically fire another process off that completion.
I was told that in order to track revenue in opportunities we would need to create a "billing" for each piece of revenue that comes in. As a non-profit that mostly receives unpredictable contributions that would mean a lot of extra work for our part-time bookkeeper. As a result we are only going to enter cash contributions in cash receipts, however, this will not communicate (out of the box) with opportunities which drive all of the dashboards and reporting. What is the easiest way to get cash receipts to duplicate in opportunities (automatically)?
When you click on the "create billing" button from the opportunity, there is a "cash sale" checkbox. If this is checked, it will create the billing and cash receipt for that opportunity. Please test this out and let me know if this works for you.
Ah ha! I knew there was a cash sale option somewhere, but I couldn't find the documentation ... it's not discussed in either the create billing nor the cash receipt pages. ...
Several customers book directly to the cash receipt if their accounting needs are simple enough. You can create a process builder to do this automatically. Also some will bundle several transactions as a journal entry. The billing is not a required approach. It is just the easiest out of the box.
Article is closed for comments.