Flexibake AR Transactions can be imported from CSV files to Restaurant365. Imported AR Transactions contain all of the transaction details and are ready for review and approval upon being imported.
AR Transactions can be imported as complete Transactions or as AR Invoice Details in to an existing AR Invoice:
- Multi-Transaction - Import multiple AR Invoices from a single file
- AR Invoice Details - Import transaction details in to one AR Invoice from a single file
Speak with your Flexibake rep about having a template set up within Flexibake and how it can be directly sent to your R365 FTP folder.
Two different kinds of Purchased Item records should be created: one for Freight Charges and one for each of the Items listed on the AR Import Template.
Record Freight Charges
Freight Charges are the costs that are charged in connection with the transportation of your goods. Because these charges will appear on your AR Imports, a Purchased Item record will then need to be created for it.
Create a new Purchased Item record and update the following on the 'General' tab:
1) Name - Freight Charges
2) Type - Purchased
3) Measure Type - Each
4) Number - Freight
5) Available in AR Invoice - Checked
Then, navigate to the 'Sales' tab and enter in the following:
6) Selling U of M - Each
7) Price Type - Set $ Amount
8) Sales Account - Select the desired Sales Account
When completed, 'Save and Close' the record.
All items in a Flexibake AR Import file must match the items listed in Restaurant365 for a successful import. To ensure that these items are matched, create new Purchased Item records for all items and enter in their necessary item details from the list below or, if not included, from this Flexibake Products file.
- Note: All items should have 'Available in AR Invoice' checked on the 'General' tab of their Purchased Item record
|Product Code||Product Name||Unit of Measure/Sell-by Unit||Pack Size||Standard Price|
|12012||CHALLAH BREAD PLAIN - 10PK||pack||10||$20.00|
|6735||CHALLAH PLAIN BAKED - LF||LF||1||$3.07|
|11203||4" CHOC MOUSSE CAKE - SL||pack||8||$25.36|
|7502||BAGEL BAKED PLAIN - DZ||dozen||1||$5.83|
|7497||BAGEL BAKED EVERYTHING - DZ||dozen||1||$5.83|
|7496||BAGEL BAKED CINNAMON RAISIN - DZ||dozen||1||$5.83|
|7507||BAGEL BAKED SESAME - DZ||dozen||1||$5.83|
|11186||MUFFIN CORN 4.5 OZ||dozen||1||$10.85|
|12079||4" CARROT CAKE - SL||pack||8||$25.36|
|11001||4" CARROT CAKE - DL||pack||8||$35.68|
|11563||4" COOKIES & CREAM CAKE - DL||pack||8||$30.88|
|6855||DANISH APPLE TURNOVER BAKED - DZ||dozen||1||$12.38|
|6857||DANISH CHEESE BAKED - DZ||dozen||1||$11.98|
|11004||4" OCCASION YELLOW CAKE - DL||pack||8||$30.88|
|8273||LG COOKIE CHOC CHUNK - BAKED - DZ||dozen||1||$10.27|
|12003||CROISSANT ROUND BAKED - DZ||dozen||1||$10.10|
|12078||4" CHOCOLATE MOUSSE CAKE -DL||pack||8||$35.02|
|WS10141||6" CHOC MOUSSE CAKE - DL||pack||6||$40.17|
|11562||4" COCONUT CAKE - DL||pack||8||$30.88|
|6873||DANISH INDY COFFEE RING BAKED - DZ||dozen||1||$14.48|
|6837||CROISSANT CHOCOLATE BAKED - DZ||dozen||1||$17.56|
|11005||4" OCCASION CHOC CAKE - DL||pack||8||$30.88|
|12080||4" RED VELVET CAKE - SL||pack||8||$25.36|
|WS10426||SCONE CRANBERRY BAKED - 4CT||pack||12||$31.20|
|8271||BW BLACK & WHITE REGULAR - DZ||dozen||1||$10.47|
|11564||4" MANHATTAN CAKE - DL||pack||8||$35.02|
Flexibake AR Import Template
The Flexibake AR Import Template will provides the details about each AR Invoice, including the different item details and the Freight Charges associated with each invoice. Click here to download the Flexibake AR Import Template.
Files can be imported in to Restaurant365 using FTP. Customers or Users can upload completed transaction files to their FTP Folder for automatic import. This folder has been automatically created for you and does not neeed a request for FTP site creation. If you aren't sure about whether you have your Restaurant365 FTP setup or have questions on how to access it, review the FTP Overview for more information.
AR Invoice Details can only be imported on an existing AR Invoice. The Invoice header must first be completed, including selecting the Customer and Location for the AR Invoice. The User should then hover over the 'Action' menu and select 'Import'.