formulas online 101 - ttb
TRANSCRIPT
![Page 1: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/1.jpg)
Formulas Online 101:Nonbeverage Alcohol ProductsFONL Version 1.6
Rachel SanderoffChemist, Nonbeverage Products
LaboratorySeptember 1, 2015
![Page 2: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/2.jpg)
Formulas Online
• Getting Started• Submitting Formulas
– Drawback– Samples– Needs Correction– Action Bar Items
• Notify• Searching
– Simple and Advanced• Common Errors and FAQs• Paper Submissions• Q&A
![Page 3: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/3.jpg)
Getting Started
![Page 4: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/4.jpg)
The First Steps
• Portal – https://ttbonline.gov
• Browser Compatibility
• Pop‐Ups
![Page 5: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/5.jpg)
https://ttbonline.gov
![Page 6: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/6.jpg)
Browser Compatibility• FONL is compatible with most browsers!
– If you are having trouble using Internet Explorer, you may have to enable ‘Compatibility View’
![Page 7: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/7.jpg)
How to enable Compatibility View…
![Page 8: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/8.jpg)
Pop-Ups
• Turn off all pop‐up blockers!– FONL utilizes pop‐up windows for most functions.
![Page 9: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/9.jpg)
Submitting Formulas
![Page 10: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/10.jpg)
Submitting Formulas
• Steps to submitting a formula– Drawback– Samples– Needs Correction– Action Bar Items
![Page 11: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/11.jpg)
Submitting Formulas
Drawback
![Page 12: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/12.jpg)
![Page 13: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/13.jpg)
Select the Company Code (from dropdown)
WLF ‐We Love Flavors6000 Ammendale RoadBeltsvilleMD20705
WLF
Choose ‘Create New Formula’ or
‘Supersede Existing Formula’
![Page 14: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/14.jpg)
TABS appear on the display of a submission. The content of the
submission is organized into specific sections.
![Page 15: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/15.jpg)
Click ‘Add’ to add a new address
Company Tab:Company Information‐Mailing Addresses‐Manufacturing Addresses‐ Contact Information
The Company address associated with the company
code will automatically prepopulate.
![Page 16: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/16.jpg)
Company Tab:Company Information‐Mailing Addresses‐Manufacturing Addresses‐ Contact Information
![Page 17: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/17.jpg)
Company Formula # = TTB #
Product Name
Product Type
Main Tab:Basic information‐ TTB #‐ Product Name‐ Product Type
![Page 18: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/18.jpg)
Formula Tab:Formula Information‐ Process Type‐ Alcohol Calculations‐ Ingredients and Yields
![Page 19: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/19.jpg)
Process TypeImportant for calculations of eligible and total alcohol
DensityFor calculating yield volumes
YieldsActual (w) – entered by submitter
Theoretical (w) – calculated based on weight of all ingredients
Volumes – calculated based on density
Measurements UsedEnglish or Metric – all weight and
volume values based on unit selected
![Page 20: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/20.jpg)
A process type must be selected…
![Page 21: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/21.jpg)
Once selected… the appropriate
windows/fields will be available on the
screen.
![Page 22: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/22.jpg)
• Simple Mixture and Filtration– Automatic calculations
• Washed Extract– Same as Simple Mixture and Filtration except ingredient fields
include a soluble check box for soluble ingredients• Other
– All possible ingredient windows available • Except dietary supplement‐specific fields
– No automatic calculations– Examples: Using ‘QS’, spray‐dry products, cakes, vanilla extracts,
bitters, etc…• Dietary Supplement
– Only an option when ‘Dietary Supplement’ is chosen as a product type (Main Tab)
– Automatic calculations– Dietary supplement‐specific fields (ex: herb information)
![Page 23: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/23.jpg)
Alcohol Beverage Use
![Page 24: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/24.jpg)
Allows for up to a value of 999,999 ppm to be entered.
![Page 25: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/25.jpg)
Alcoholic Components & Compounded Flavors
![Page 26: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/26.jpg)
• Eligible Alcohol– Alcohol eligible for drawback of tax
• Ex: 190 proof alcohol• Disapproved Intermediates
– In‐house products previously disapproved– Can be used in a subsequent approved product– Eligible for drawback of tax
• Ineligible Alcohol– Not eligible for drawback of tax (wine, beer)– Can be in‐house flavor or purchased product
![Page 27: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/27.jpg)
Checking the box opens the section and allows for more information to be entered.
![Page 28: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/28.jpg)
Clicking ‘Add’ button displays a pop‐up
window for ingredients.
* Indicates a required field
![Page 29: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/29.jpg)
Density calculates based on weight and volume entered.
(used as a check)
![Page 30: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/30.jpg)
![Page 31: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/31.jpg)
Choose ‘Y’ or ‘N’ for Colors and Limited Ingredients. If ‘Y’ chosen, a text field opens and requires more information.
Can search and link formulas already in the
FONL system(or enter in Co. Code and TTB #)
1001258
![Page 32: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/32.jpg)
![Page 33: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/33.jpg)
Washed Extracts…Must indicate which ingredients are soluble. Calculations of total alcohol are based on
the total of all soluble ingredients.
Soluble checkbox
![Page 34: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/34.jpg)
Nonalcoholic Components
![Page 35: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/35.jpg)
• Ingredients by Group– Chemical groupings based on the guidelines in the Drawback Tutorial
• Individual Solid Ingredients– Ex: Vanillin, Citric Acid, etc…
• Individual Liquid Ingredients– Ex: Water, PG, oils, etc…
![Page 36: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/36.jpg)
Checking the box opens the section and allows for more information to be entered.
![Page 37: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/37.jpg)
Clicking ‘Add’ button displays a pop‐up
window for ingredients.
![Page 38: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/38.jpg)
![Page 39: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/39.jpg)
![Page 40: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/40.jpg)
Limited Ingredients dropdown – ‘Yes’ or ‘No’If ‘Yes’ selected, more information is required.
![Page 41: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/41.jpg)
Bug – ‘*’ for Volume fieldThis is not a mandatory field (except for washed extracts), it is a display issue. But
the other fields are still mandatory.
![Page 42: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/42.jpg)
![Page 43: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/43.jpg)
Eligible Alcohol Total Alcohol and Tolerance
Theoretical Yield (weight and volume)
Actual Yield (volume)
All calculations are completed automatically!
![Page 44: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/44.jpg)
Additional Details:‐ Unfit for Beverage Use Statement (mandatory)‐ Taste Panel Results
‐ Refer to Drawback Tutorial for organoleptic testing information
‐ Formula Information and Process
![Page 45: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/45.jpg)
Docs/Links Tab:‐Upload files
‐Spec sheets
‐FIDs
‐Etc…
‐Link FONL submissions‐Reference purposes
![Page 46: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/46.jpg)
![Page 47: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/47.jpg)
Browse for the file on your
computer and upload it to the submission
![Page 48: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/48.jpg)
Comments Tab:‐ Comments can be added by submitter and TTB at any time.
![Page 49: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/49.jpg)
![Page 50: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/50.jpg)
![Page 51: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/51.jpg)
Buttons – What do they do?
Save as Draft:Saves the incomplete submission to be
completed later. Does not check for errors.
Validate:Checks for errors.
Cancel:Cancels and deletes the formula.
Submit:Validates and submits to TTB.
NOTE: The formula cannot be edited once submitted!
![Page 52: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/52.jpg)
Once Submitted…
![Page 53: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/53.jpg)
Email received after formula is submitted.
![Page 54: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/54.jpg)
WLF ‐We Love Flavors6000 Ammendale RoadBeltsvilleMD20705
WLF
Superseding Formulas
![Page 55: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/55.jpg)
![Page 56: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/56.jpg)
Superseding Formulas:‐ Fill in information‐ The information will display on the Main Tab.
![Page 57: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/57.jpg)
WLF ‐ 5
![Page 58: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/58.jpg)
Submitting Formulas
Samples
![Page 59: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/59.jpg)
Samples Tab:* Used only if a sample is needed
‐ Enter sample information
![Page 60: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/60.jpg)
![Page 61: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/61.jpg)
2.0
TTB #78
oz
Will say pending until the formula is submitted.
Date Received is completed by lab
![Page 62: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/62.jpg)
Submission Confirmation screen
reminds you to go back to the Samples Tab.
![Page 63: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/63.jpg)
Back to the Samples tab…Check the box next to the Sample ID # and use the drop down and click ‘Go’
to print a Sample ID sheet.
![Page 64: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/64.jpg)
MUST BE MAILED WITH THE SAMPLE!Contains ID numbers to connect the
sample with the submission.
** The formula will not be processed until the sample is received. **
![Page 65: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/65.jpg)
Email received after sample is received by the lab.
![Page 66: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/66.jpg)
Submitting Formulas
Needs Correction
![Page 67: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/67.jpg)
If the submission is returned for correction, you will receive an email
notification.
![Page 68: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/68.jpg)
Needs Correction Tab:‐ Only visible if the submission is returned for correction
‐ Contains reason and description of error(s)
![Page 69: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/69.jpg)
The lab will check the ‘Resolved?’ check box after the formula is
resubmitted.
The Return tab and reasons for the return will remain with the
submission even after the error is corrected and final action is taken.
Needs Correction StatusThe formula can be
edited and resubmitted to TTB.
![Page 70: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/70.jpg)
Submitting Formulas
Action Bar Items
![Page 71: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/71.jpg)
Action Bar:‐ Available actions depend on the status of the submission
Copy as New:Create a new submission by copying the formula.
Print:Print entire submission or specific tabs.
Comment:Displays the Comment pop‐up window to add a
comment to the submission.
Notify:Displays the Create E‐Mail pop‐up window. Allows user
to send TTB staff an email.
Withdraw:Can withdraw an in‐process submission and cancel it
permanently.
![Page 72: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/72.jpg)
Notify
![Page 73: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/73.jpg)
Notify Function
• The Notify function allows a user to send an email through the FONL system
• Email can be sent to TTB staff– Ex: chemist assigned to a formula
• Messages can be sent no matter the status of the submission
• A better option than adding a comment to submission – we receive an email
![Page 74: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/74.jpg)
![Page 75: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/75.jpg)
Notify E‐Mail pop‐up:Click on “To” to display
contact list.
![Page 76: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/76.jpg)
After message is sent, a copy of the email message is
added to the Comments Tab
![Page 77: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/77.jpg)
Searching
![Page 78: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/78.jpg)
Simple SearchSearch by:‐ Submission ID #‐ Sample ID #‐ Formula ID #‐ Attachment ID#
![Page 79: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/79.jpg)
Advance SearchMany more search options
![Page 80: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/80.jpg)
More specific search options are available when a
‘Submission Name’ is selected
Can only search for your company’s submissions.
![Page 81: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/81.jpg)
Common Errors and Frequently Asked Questions
![Page 82: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/82.jpg)
Common Errors
• Required fields• Process Type• Theoretical Yield
– Entering all ingredients
• Actual Yield
![Page 83: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/83.jpg)
Common Errors
• Required Fields– Any fields marked with asterisks (*) are required fields
– Validation of a formula checks to make sure all required fields are filled in
– Formula cannot be submitted if a required field is not filled in
![Page 84: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/84.jpg)
Common Errors
• Process Type– Must be selected before any ingredient information can be entered
– Fields available depend on process type chosen
• Examples: – Washed Extracts ‐ includes soluble check box– Dietary Supplements ‐ different windows are available
– Other – all possible fields are available
![Page 85: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/85.jpg)
Common Errors
• Process Type– Cannot be changed once an ingredient is entered.
– If it needs to be changed…• Delete all ingredients• Change process type• Re‐enter ingredients
![Page 86: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/86.jpg)
Common Errors
• Theoretical Yield– Calculates automatically
• Weight – Sum of all ingredients added
• Volume– Calculates based on density entered
– Missing ingredients will cause the theoretical yield and total alcohol content to calculate incorrectly
![Page 87: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/87.jpg)
Common Errors
• Actual Yield– Weight
• Entered by submitter– Volume
• Calculated based on density entered
• Should not be higher than the theoretical yield.
• If not entered, alcohol calculations will not be done.
![Page 88: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/88.jpg)
Frequently Asked Questions
• Workflow and Status
• Submission ID # vs. Formula ID #
• Needs Correction vs. Supersedes
• FONL Help
![Page 89: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/89.jpg)
Submission Status• What are the different Submission Statuses?
– Items Pending• Sample information entered on Sample Tab, but sample not yet received by the lab.
– Assignment Pending• The submission is awaiting assignment within the laboratory.
– Lab Analysis• Formula review is in progress.
– QA Review or Correction Review• The submission is awaiting review by the NPL Chief.
– Needs Correction• The submission is returned to the submitter. It can be edited and re‐submitted.
– Closed• The submission is complete. Cannot be edited.
![Page 90: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/90.jpg)
With a Sample?
Status: Items Pending
Status: Assignment Pending
(formula waiting to be assigned to a chemist)
Status: Lab Analysis(chemist processing formula) Status:
Closed
Status: Needs Correction
Paper Submissions
Electronic Submissions
NO
YES SAMPLERECEIVED
FORMULAAPPROVED ORDISAPPROVED
FORMULARETURNED
FONL Workflow
Status: QA Review orCorrection Review(formula is awaiting review by
NPL Chief)
![Page 91: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/91.jpg)
Submission ID # vs. Formula ID #• Submission ID #
– Unique identifier on each submission – Given when the submission is created
• Formula ID #– Unique identifier for a formula for which a company has provided submissions
– Formula can have multiple submission ID#s• Example:
– Approved formula resubmitted with yield changes
• Same Formula ID # • Different Submission ID #
![Page 92: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/92.jpg)
Needs Correction vs. Supersedes
• Needs Correction– FONL status – Formula has been reviewed by TTB but cannot be approved as submitted
– Formula can be edited and resubmitted• Supersedes
– Overwrites previous submission• Changes to an already approved/disapproved/no action formula
– Except when new TTB# is required
![Page 93: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/93.jpg)
Frequently Asked Questions
• Help files
![Page 94: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/94.jpg)
Clicking on the will bring up the help files specific to that subject
Hovering your cursor over certain fields
my pop‐up a help tip
Clicking on the ‘Help’ link in the menu brings up a pop‐up
to open a user manual
![Page 95: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/95.jpg)
Paper Submissions
![Page 96: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/96.jpg)
Paper Submissions• Electronic and paper submissions are processed through FONL– Paper submissions are scanned and uploaded– If the submitter is in the system…
• Emailed notifications of submission disposition or needs correction status
• Will not receive a mail copy– If the submitter is not in the system…
• No longer receive a stamped formula– Mailed a copy of the FONL Formula Summary
» Shows disposition and date of disposition– Mailed a copy of the FONL Formula Correction Summary
» Similar to return sheets
![Page 97: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/97.jpg)
FONL Formula Summary
Formula Information
FONL ID #s
Disposition and Date of Disposition
![Page 98: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/98.jpg)
FONL Formula Correction Summary FONL ID #s
Formula Information
Needs Correction Information(Return reasons)
![Page 99: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/99.jpg)
Q & A
![Page 100: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/100.jpg)
Q&A
• If multiple people from the same company register for FONL, will they be able to see all submitted formulas from the company?– Yes. – But, formulas will only show up on your ‘My Submissions’ page if you are listed as the submitter.
– Use the search functions to view all submissions from company.
![Page 101: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/101.jpg)
Q&A
• If I have a paper submission that was returned for correction, can I mail in the corrected submission?– Yes, you can mail in the corrected submission.
– You can also submit it electronically.
![Page 102: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/102.jpg)
Q&A
• I have a purchased product that does not contain alcohol. Where do I put that ingredient in?– It can be entered either in the Ineligible Alcohol section (alcohol values are 0) or in the appropriate Nonalcoholic Component section.
• Be sure all limited ingredient information is included.
• Attach a spec sheet if needed.
![Page 103: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/103.jpg)
Q&A
• I noticed a mistake in a submission after I submitted it. Is there a way for me to make changes once it is submitted?– No changes can be made once submitted.
• We cannot change anything internally.
– Use the notify function to contact NPL Chief and/or chemist and request the submission be returned for correction.
![Page 104: Formulas Online 101 - TTB](https://reader031.vdocuments.us/reader031/viewer/2022020916/61a90bfb20d02a4920226221/html5/thumbnails/104.jpg)
Questions?
• Please send any questions to [email protected] or to [email protected]
• Presentation will be posted on the TTB.gov website